
gen country=""
replace country = "Albania" if ccode == "ALB"
replace country = "Argentina" if ccode == "ARG"
replace country = "Austria" if ccode == "AUT"
replace country = "Bulgaria" if ccode == "BGR"
replace country = "Bolivia" if ccode == "BOL"
replace country = "Brazil" if ccode == "BRA"
replace country = "Botswana" if ccode == "BWA"
replace country = "Switzerland" if ccode == "CHE"
replace country = "Chile" if ccode == "CHL"
replace country = "Costa Rica" if ccode == "CRI"
replace country = "Cyprus" if ccode == "CYP"
replace country = "Czech Republic" if ccode == "CZE"
replace country = "Denmark" if ccode == "DNK"
replace country = "Dominican Republic" if ccode == "DOM"
replace country = "Ecuador" if ccode == "ECU"
replace country = "Egypt, Arab Rep." if ccode == "EGY"
replace country = "Spain" if ccode == "ESP"
replace country = "Estonia" if ccode == "EST"
replace country = "France" if ccode == "FRA"
replace country = "United Kingdom" if ccode == "GBR"
replace country = "Georgia" if ccode == "GEO"
replace country = "Greece" if ccode == "GRC"
replace country = "Guyana" if ccode == "GUY"
replace country = "Croatia" if ccode == "HRV"
replace country = "Hungry" if ccode == "HUN"
replace country = "Iceland" if ccode == "ISL"
replace country = "India" if ccode == "IND"
replace country = "Ireland" if ccode == "IRL"
replace country = "Italy" if ccode == "ITA"
replace country = "Lithuania" if ccode == "LTU"
replace country = "Luxembourg" if ccode == "LUX"
replace country = "Latvia" if ccode == "LVA"
replace country = "Mexico" if ccode == "MEX"
replace country = "Malta" if ccode == "MLT"
replace country = "Mongolia" if ccode == "MNG"
replace country = "Nicaragua" if ccode == "NIC"
replace country = "Netherlands" if ccode == "NLD"
replace country = "Peru" if ccode == "PER"
replace country = "Philippines" if ccode == "PHL"
replace country = "Poland" if ccode == "POL"
replace country = "Portugal" if ccode == "PRT"
replace country = "Paraguay" if ccode == "PRY"
replace country = "Romania" if ccode == "ROU"
replace country = "Slovakia" if ccode == "SVK"
replace country = "Slovenia" if ccode == "SVN"
replace country = "Sweden" if ccode == "SWE"
replace country = "United States" if ccode == "USA"
replace country = "Palestine" if ccode == "WBG"
replace country = "South Africa" if ccode == "ZAF"
